C2090-623: IBM Cognos Analytics Administrator V11

An administrator wants to ensure that a datasource can be referenced when creating data modules in the IBM Cognos Analytics Portal (New > Data module). What must be done to accomplish this?

Add the datasource to the list of supported datasources in IBM Cognos Configuration.
Configure the datasource in IBM Cognos Transformer so that it can communicate with the portal.
In the web-based modeling tool itself, specify the ‘Create Data Modules’ access permission for the datasource.
On the Connection tab of the datasource properties, ensure that the ‘Allow web-based modeling’ check box is selected.

Correct answer: D

Explanation:

Problem(Abstract): Datasource connections not listed in Data server by defaultSymptom: We can see the datasource in the Admin console but not in the list of data servers.Cause: This is default behavior.Resolving the problemGo to the Administrative Console -> Configuration -> Set properties -> Connections tab.On the bottom, you will see "Data source capabilities"Inside that, check the box which says "Allow web-based modeling" Once you check this, the datasource would be present as data server.References: http://www-01.ibm.com/support/docview.wss?uid=swg21978718

Problem(Abstract): Datasource connections not listed in Data server by default

Symptom: We can see the datasource in the Admin console but not in the list of data servers.

Cause: This is default behavior.

Resolving the problem

Go to the Administrative Console -> Configuration -> Set properties -> Connections tab.

On the bottom, you will see "Data source capabilities"

Inside that, check the box which says "Allow web-based modeling" Once you check this, the datasource would be present as data server.

References: http://www-01.ibm.com/support/docview.wss?uid=swg21978718

An administrator wants to render a report and ensure the completed HTML is sent back to the gateway.

Which service is responsible for the rendering task?

Report service
Delivery service
Presentation service
Content Manager service

Correct answer: C

Explanation:

The Presentation serviceTransforms generic XML responses from another service into output format, such as HTML or PDFProvides display, navigation, and administration capabilities in IBM Cognos ConnectionIncorrect Answers:A: The Report service manages interactive requests to run reports and provides output for a user in IBM Cognos Connection or a studio.B: The Delivery service sends emails to an external SMTP server on behalf of other services, such as the report service, job service, agent service, or data integration serviceD: The Content Manager service:Performs object manipulation functions in the content store, such as add, query, update, delete, move, and copy Performs content store management functions, such as import and exportReferences: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 139

The Presentation service

Transforms generic XML responses from another service into output format, such as HTML or PDF
Provides display, navigation, and administration capabilities in IBM Cognos Connection

Incorrect Answers:

A: The Report service manages interactive requests to run reports and provides output for a user in IBM Cognos Connection or a studio.

B: The Delivery service sends emails to an external SMTP server on behalf of other services, such as the report service, job service, agent service, or data integration service

D: The Content Manager service:

Performs object manipulation functions in the content store, such as add, query, update, delete, move, and copy Performs content store management functions, such as import and export

References: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 139

An environment has the following routing rules set:

If a report using the ‘Australia Package’ is run by a user belonging to ‘Australia Group’, which server group will the request be sent to?

Group 1
Group 2
The request will be sent to the first available server because there is more than one rule for the Australia Package.
The request would fail because there is more than one rule for the Australia Package and only one for the Australia group.

Correct answer: B

Explanation:

Explanation/Reference:Unlike routing keywords, the order in which the routing rules are listed affects how they are applied.A rule is matched when properties associated with the package or the group or role involved in the request satisfy the criteria of the rule. The rules are evaluated in order until the first one is matched, and the request is routed to the server group named by the first rule that was matched. You can change the order of the rules by clicking Modify the sequence.References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/ t_asg_set_routing_keywords_server.html

Explanation/Reference:Unlike routing keywords, the order in which the routing rules are listed affects how they are applied.

A rule is matched when properties associated with the package or the group or role involved in the request satisfy the criteria of the rule. The rules are evaluated in order until the first one is matched, and the request is routed to the server group named by the first rule that was matched. You can change the order of the rules by clicking Modify the sequence.

References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/ t_asg_set_routing_keywords_server.html

All users have unrestricted access in a secured environment. What must be modified to control this access?

Delete the "All Authenticated Users" group.
Disable anonymous access using IBM Cognos Configuration.
Modify the advanced properties of the authorization namespace.
Remove the "Everyone" group from the "System Administrators" role.

Correct answer: B

Explanation:

You can disable the Anonymous user account by changing the configuration parameters in the configuration tool.This entry represents a user account shared by members of the general public who can access IBM Cognos software without being prompted for authentication. For example, this type of access is useful when distributing an online catalog.Anonymous users can see only those entries for which access permissions are not set, or are set specifically for this account or for the Everyone group.Incorrect Answers: A: The built-in entries include the Anonymous user account, the groups All Authenticated Users and Everyone, and the role System Administrators. You cannot delete the built-in entries. They appear in both secured and non-secured environments.References: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 297

You can disable the Anonymous user account by changing the configuration parameters in the configuration tool.

This entry represents a user account shared by members of the general public who can access IBM Cognos software without being prompted for authentication. For example, this type of access is useful when distributing an online catalog.

Anonymous users can see only those entries for which access permissions are not set, or are set specifically for this account or for the Everyone group.

Incorrect Answers:

A: The built-in entries include the Anonymous user account, the groups All Authenticated Users and Everyone, and the role System Administrators. You cannot delete the built-in entries. They appear in both secured and non-secured environments.

References: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 297

The database containing the Content Store crashed. The administrator needs to restore the Content Store in its entirely including all of the configuration settings that were defined.

What must be done to recover the configuration settings?

The configuration settings are automatically included when running the import.
Manually apply the settings because configuration settings are not a part of the Content Store deployment.
Configuration settings are not included in the Content Store deployment. The parameter CM.DEPLOYMENTINCLUDECONFIGURATION must be set to true on the ContentManagerService prior to running the Content Store export deployment.
Configuration settings are included in the Content Store deployment but not included in the import unless you set the parameter CM.DEPLOYMENTINCLUDECONFIGURATION to true on the ContentManagerService before running the import.

Correct answer: C

Explanation:

Specify if Configuration Objects and Children are Part of Deployment.You can specify if configuration objects and their children are included as part of deployment. By default, they are not included.You can change the default setting using the advanced setting CM.DEPLOYMENTINCLUDECONFIGURATION. By default, it is set to False (do not include configuration objects in deployments).To change the default to include configuration objects and their children, set it to True.References: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 384

Specify if Configuration Objects and Children are Part of Deployment.

You can specify if configuration objects and their children are included as part of deployment. By default, they are not included.

You can change the default setting using the advanced setting CM.DEPLOYMENTINCLUDECONFIGURATION. By default, it is set to False (do not include configuration objects in deployments).

To change the default to include configuration objects and their children, set it to True.

References: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 384

An environment is configured to use Compatible Query Mode (CQM). Which statement is true about request flow?

OLAP, DMR and Relational components reside in the same Adapters layer.
OLAP, UDA and DMR components reside in the same Query Execution layer.
OLAP, Relational and DMR components reside in the same Query Planning layer.
OLAP, DMR and Relational components reside in the same Query Execution layer.

Correct answer: C

Explanation:

OLAP style queries, like those against SAP BW, Oracle Essbase and IBM Cubing Services type data sources, will go to the OLAP query planner.References: The IBM Cognos 10 Dynamic Query Cookbook (2010), page 7

OLAP style queries, like those against SAP BW, Oracle Essbase and IBM Cubing Services type data sources, will go to the OLAP query planner.

References: The IBM Cognos 10 Dynamic Query Cookbook (2010), page 7

A user needs to create a data module that uses a datasource named MyDatabase. What actions must be taken to enable the user to access this datasource?

Using Manage, click on Data servers, click on + and choose the appropriate database type, name the connection "MyDatabase" and supply the appropriate connection details to connect to the data source.
Using New, click on Data Module, select Data servers, click on the + to add a new data server, choose the appropriate database type, name the connection "MyDatabase" and supply the appropriate connection details to connect to the data source.
Using Manage, click on Administration console, then click on "New Data Source" within the Data Source Connections option under the Configuration tab. Select the appropriate database type, name the data source "MyDatabase" and supply the appropriate connection details to connect to the data source.
Using Manage, click on Administration console, then click on "New Data Server" within the Data Source Connections option under the Configuration tab. Select the appropriate database type, name the data source "MyDatabase" and supply the appropriate connection details to connect to the data source.

Correct answer: C

Explanation:

You can combine multiple sources into one data module. After you add a source, click Add sources (Add a data source.) in Selected sources to add another source. References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ca_mdlg.doc/c_data_modules.html

An administrator needs to exclude users from rendering reports as PDF output.

How can this be enabled?

Modify the permissions for the generate PDF Output capability.
Use Theme Manager to remove the generate PDF Output option.
Create a role name "PDF output", add the built-in entry group name "Everyone" and set the permission to Deny.
Modify the file located in <install>\templates\ps\system.xml, locate the line <format id="PDF>", and add the following attribute enabled="false".

Correct answer: A

Explanation:

By default, all users have permissions for the following capabilities:Generate CSV OutputGenerate PDF OutputGenerate XLS OutputGenerate XML OutputThese separately secured functions support the management of system resources. To control the formats options that users can see and run in the user interface, set access permissions for these capabilities.References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/c_specifyreportformat.html

By default, all users have permissions for the following capabilities:

Generate CSV Output
Generate PDF Output
Generate XLS Output
Generate XML Output

These separately secured functions support the management of system resources. To control the formats options that users can see and run in the user interface, set access permissions for these capabilities.

References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/c_specifyreportformat.html

In a LifeCycle Manager Project, a user can create either a Benchmark task or a Comparison task. Which statement is INCORRECT when describing the application of Benchmark tasks?

Benchmark tasks can be used as a benchmark test for any LifeCycle Manager Project.
Benchmark tasks can be used to create a benchmark test to run Compatible Query Mode (CQM) reports as Dynamic Query (DQ) reports.
When creating a Benchmark task, the administrator can choose whether to validate reports before they are run, and whether to run the reports in Dynamic Query Mode (DQM).
To use a previously run Benchmark, select a previously created Benchmark task for the benchmark source and the target Cognos server that you want to compare to the benchmark.

Correct answer: C

Explanation:

Incorrect Answers:B: You can run CQM reports in DQM in a Lifecycle Manager project as part of the CQM to DQM migration validation.D: Users can compare live Cognos environments, or static files using previously saved Benchmark tasks. Benchmark allows you to create a point-in-time snapshot and use that as a baseline comparison.Note: Lifecycle Manager is a stand-alone application that helps validate and compare report outputs within a single environment, between environments or between different versions of Cognos.References: https://www.ibm.com/communities/analytics/cognos-analytics-blog/cognos-lifecycle-manager-enhancements-in-11-0-4/

Incorrect Answers:

B: You can run CQM reports in DQM in a Lifecycle Manager project as part of the CQM to DQM migration validation.

D: Users can compare live Cognos environments, or static files using previously saved Benchmark tasks. Benchmark allows you to create a point-in-time snapshot and use that as a baseline comparison.

Note: Lifecycle Manager is a stand-alone application that helps validate and compare report outputs within a single environment, between environments or between different versions of Cognos.

References: https://www.ibm.com/communities/analytics/cognos-analytics-blog/cognos-lifecycle-manager-enhancements-in-11-0-4/

Which statement is true about the Default User Profile?

It includes the option to disable hints.
It is used only for the initial login of a user.
A change will have an effect only after a user’s next login.
It is defined in the IBM Configuration Portal, under the Dispatchers and Services section.

Correct answer: A

Explanation:

Incorrect Answers:B, C: When a tenant user logs on to IBM Cognos software for the first time, the user profile is automatically created for the user. The profile is based on the tenant user profile, if one exists. If a tenant profile does not exist, the default user profile is applied to the user. The default user profile is defined in the Cognos namespace. It contains settings that apply to all new users. You can edit the default user profile for your users to minimize the number of changes you need to make to individual user profiles.D: ProcedureIn IBM Cognos Administration, click the Multitenancy tab.Choose the applicable action:To create the user profile for one or more tenants, select the tenant check boxes, and click the Edit default user profile icon Edit default user profile icon in the toolbar. If required, make changes on the different tabs.To change an existing user profile for one tenant, from the tenant Actions drop-down menu, click Edit tenant user profile, and make the required changes on the different tabs.References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/t_asg_mt_userprofile.html

Incorrect Answers:

B, C: When a tenant user logs on to IBM Cognos software for the first time, the user profile is automatically created for the user. The profile is based on the tenant user profile, if one exists. If a tenant profile does not exist, the default user profile is applied to the user.

The default user profile is defined in the Cognos namespace. It contains settings that apply to all new users. You can edit the default user profile for your users to minimize the number of changes you need to make to individual user profiles.

D: Procedure

In IBM Cognos Administration, click the Multitenancy tab.
Choose the applicable action:
To create the user profile for one or more tenants, select the tenant check boxes, and click the Edit default user profile icon Edit default user profile icon in the toolbar. If required, make changes on the different tabs.
To change an existing user profile for one tenant, from the tenant Actions drop-down menu, click Edit tenant user profile, and make the required changes on the different tabs.

References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/t_asg_mt_userprofile.html

Vendor:	IBM
Exam Code:	C2090-623
Exam Name:	IBM Cognos Analytics Administrator V11
Date:	Mar 08, 2019
File Size:	442 KB

Download IBM Cognos Analytics Administrator V11.C2090-623.PassCertification.2019-03-08.38q.vcex

How to open VCEX files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown